package com.zbl.zblproject.member.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zbl.zblproject.member.entity.Member;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * @author youlanqiang
 * @version 1.0
 * @date 2019/3/27
 */
@Repository
public interface MemberMapper extends BaseMapper<Member> {

    @Select("SELECT * FROM zbl_member WHERE open_id = #{openId}")
    Member searchByOpenId(String openId);

    @Select("SELECT * FROM zbl_member WHERE telephone = #{telephone}")
    Member searchByTelephone(String telephone);

}
